| |
47 Search Results Found |
| 1 |
Forum: Server Administration «»
Posted on: Wed, 06 December 2017 21:08 «»
By: lzfhope
Re: global temporay table does not work!
…Today,i found that init parameter "temp_undo_enabled" is set to true,which is the only changed parameter recently!
Have a try,restored it to "false"!
as a result,global temporary table(on commit preserve) could still hold data …
|
| 2 |
Forum: SQL & PL/SQL «»
Posted on: Sun, 27 August 2017 13:00 «»
By: rkrishna
Re: Bulk Inserts with CLOB column Slower in Oracle 12c than Oracle 11g
…are in the verge of making the decision to upgrade to 12c, and this extremely slow performance on Inserts is a major blocker. The expectation is that 12c should be at least as fast as 11g, if not better. I am looking for any suggestion on whether we need …
|
| 3 |
Forum: Weblogic & Application Server «»
Posted on: Mon, 05 December 2016 04:34 «»
By: calacausi
Oracle App. Server 10g. error when accessing file on a remote server
…hi,
i need my Forms application access files stored in a remote server. I checked that \\OASServer and \\RemoteServer computers are in the same domain, and the remote directory \\RemoteServer\temp is shared and has full control rights assigned to '…
|
| 4 |
Forum: Reports & Discoverer «»
Posted on: Sun, 04 December 2016 02:31 «»
By: iam78
discoverer 11g configuration fails
…have installed weblogic 10.3.6 and discoverer 11.1.1.2 and discoverer patchset 11.1.1.7,
in the step of configuration of instance when create managed server wls_disco it take a huge time and last it give me error!!!
i read all forums withe same …
|
| 5 |
Forum: Windows «»
Posted on: Wed, 06 May 2015 23:16 «»
By: dark_prince
Re: How to Insert / Retrieve data in Marathi / Hindi font
…guys. I drop the database. And now for creating new database I found script, I thought before running it i should show that to you guys.
REM ASSUMPTIONS
rem oracle xe has been installed
rem oracle_home has been set
rem oracle_sid has been set
…
|
| 6 |
Forum: Performance Tuning «»
Posted on: Thu, 17 October 2013 09:57 «»
By: hesaigo999ca
Re: Help with 12c vs 10.2g
…all for being patient and lots of suggestions...
Here so far is extra info as well as the progress I have made so far.
Info...
Roachcoach:I do know what the jobs are doing, the sql is the same in both cases, hence why I consider this to be simple and…
|
| 7 |
Forum: Performance Tuning «»
Posted on: Thu, 11 April 2013 10:52 «»
By: Michel Cadot
Re: How to find out session consuming high resource in the past?
…Ah! you were talking about the columns... I thought the view... sorry.
They indeed are there only in 11g:
mikb2=MIKB2/ILLUVATAR MICHEL> desc DBA_HIST_ACTIVE_SESS_HISTORY
Name Null? Type…
|
| 8 |
Forum: Application Express, ORDS & MOD_PLSQL «»
Posted on: Sun, 24 February 2013 07:10 «»
By: BLROracle
create remote file with util_file
…Hello,
i´am a newon pl/sql and i have question about util_file.
My environment:
Database is installed on some server, which i have no access.
I have to export some data from this database.
1.At first, i have to create some csv and xml files.
…
|
| 9 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 16:58 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…is reports for DIRECT PATH insert. My observations:
*REDO size reduced by two orders of magnitude, not surprising
*Essentially everything in the Load Profile is reduced by an order of magnitude or more on a per transaction
*On a per second basis much …
|
| 10 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 15:15 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…have changed sequence cache to 100,000 per your recommendation. This change chops about .4ms from my elapsed time per execution. The first two reports (907-908) were run at the same load volume as all my previous reports, then I decided to run my load …
|
| 11 |
Forum: Performance Tuning «»
Posted on: Wed, 17 October 2012 10:00 «»
By: segan1415
Re: NOLOGGING in Oracle 11gr2
…seems from the new AWRRPT, I am now swapping log files every fifteen minutes (since there is only 1 switch, I ran a second awrrpt from 801-803 and there was 2 switches - confirming this)
AWRRPT 801-802 (50M REDO LOG FILES)
Toggle Spoiler
WORKLOAD…
|
| 12 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 06 September 2012 10:24 «»
By: Michel Cadot
Re: Remote Pipeline or Remote sys_refcursor
…
No, it's me, I was not clear, I was going back to your initial question and ask if you can't from your application open a connection to the other (remote) database and directly get the result from it instead of getting through a db link.
For your …
|
| 13 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 08 February 2012 01:03 «»
By: aallan
Re: Attache external file using UTL_SMTP package
…Amit;
I user this procedure but i have a problem with the attached file, it as arrive in the sent email but attached file has a wrong data!!
if you can solve it i will appreciate that.
Create Or Replace Procedure Sale.Html_Email_With_Attach(
…
|
| 14 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 07:42 «»
By: aallan
Re: Create HTML table problem in email
…you...
i searched and found this code:
Create Or Replace Procedure Sale.Html_Email_With_Attach(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 15 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 06 February 2012 02:03 «»
By: aallan
Create HTML table problem in email
…Dears;
I used this procedure to send html email:
Create Or Replace Procedure Sale.Html_Email(
P_To In Varchar2,
P_Cc In Varchar2 Default Null,
P_Bcc In Varchar2 Default Null,
P_From In …
|
| 16 |
Forum: Server Administration «»
Posted on: Wed, 01 February 2012 00:32 «»
By: x-oracle
Re: ora 01092 oracle instance terminated
…i am sending you a complite steps of how can we create a manul database you just read it and just change the path and name of the database as you want
first
1. Decide the name of New database
2. ORACLE_SID=ORA10G... (set into Env variable )
3…
|
| 17 |
Forum: Networking and Gateways «»
Posted on: Wed, 25 January 2012 21:31 «»
By: reym21
dblinks
…day!
Please help me to connect Oracle 10g (connecting dB) to Oracle 7.3.4 (remote dB) via dblink (both in DEV environment). I encounter these errors everytime I attempted to, re:
ORA-12545: Connect failed because target host or object does not exist…
|
| 18 |
Forum: Server Administration «»
Posted on: Mon, 19 December 2011 23:20 «»
By: Bilal Khan
DATABASE CREATION
…all.
i wana create database in oracle 10g, but it display error mesage.
i follow following steps
C:\SET ORACLE_SID = ALI
THEN CREATE PASSWORD FILE,AND STARTUP THE PFILE, THEN RUN FOLLOWING CODE TO CREATE THE DATABASE.
CREATE DATABASE ali
…
|
| 19 |
Forum: SQL & PL/SQL «»
Posted on: Mon, 14 November 2011 12:10 «»
By: tuchubby
Querying through dynamic database links using DBMS_SQL
…is my first post here, please forgive me for anything that I missed. I am using SQL Developer.
I am self-teaching myself PL/SQL. What I am trying accomplish is to run a select query across many database links at runtime and to insert that query onto a …
|
| 20 |
Forum: Linux «»
Posted on: Sat, 24 September 2011 14:56 «»
By: JiXO
Re: Enterprise Manager error
…is the content of alert_orcl.log
Thu Sep 22 17:17:33 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Shared memory segment for instance monitoring created
Picked latch-free SCN scheme 2
Using …
|
| 21 |
Forum: Performance Tuning «»
Posted on: Fri, 02 September 2011 07:08 «»
By: msol25
Re: how we can match variable sga using v$sga and v$sgastat views
…Michel,
Please find details :
SQL> select * from v$sga;
NAME VALUE
-------------------- ----------
Fixed Size…
|
| 22 |
Forum: Server Utilities «»
Posted on: Tue, 02 August 2011 05:28 «»
By: dkdms2124
Re: Clone Database user
…I run the Batch file, I got below mentioned error:
--------------------------------------------------------------------------------
Create a new schema/user like an existing schema/user.
Defaults are shown between brackets…
|
| 23 |
Forum: Server Administration «»
Posted on: Wed, 04 May 2011 01:13 «»
By: Michel Cadot
Re: database in mount mode
…that work and those that does not work (in 10.2.0.4).
DO NOT WORK:
GV$AQ1
GV$LOGMNR_CONTENTS
GV$LOGMNR_REGION
GV$LOGSTDBY_PROGRESS
GV$LOGSTDBY_STATE
GV$RSRC_PLAN_HISTORY
GV$SEGMENT_STATISTICS
GV$STREAMS_CAPTURE
GV$TEMP_EXTENT_MAP
GV$…
|
| 24 |
Forum: Linux «»
Posted on: Mon, 02 May 2011 13:10 «»
By: juniorpeardba
Re: SQL Plus no access
…Hi,
log file from installation
more installActions2011-04-28_02-48-23PM.log
Using paramFile: /opt/oracle/Disk1/install/oraparam.ini
Checking Temp space: must be greater than 80 MB. Actual 2693 MB Passed
Checking swap space: must be greater …
|
| 25 |
Forum: Server Administration «»
Posted on: Wed, 23 February 2011 08:43 «»
By: vik28
Migrating Oracle 9i to 10g
…Gurus,
I'm trying to migrate an Oracle Enterprise Server database v9.2.0.1.0 deployed on Windows 2000 Server 32-bit to v10.2.0.5.0 on Windows 2008 R2 64-bit.
Basically, I'm following instructions provided by this document:
h**p://download.oracle.…
|
| 26 |
Forum: Server Administration «»
Posted on: Mon, 27 December 2010 04:34 «»
By: debakor
ORA-01079
…i want to create manual database its give the error message ORA-01092 Here i give the create database command and my parameter file.
SQL> create database dba16
2 MAXLOGFILES 5
3 MAXLOGMEMBERS 5
4 …
|
| 27 |
Forum: Data Guard «»
Posted on: Tue, 21 September 2010 03:27 «»
By: artisteprasanna
ORA-01154: database busy. Error in Creating Physical StandBy Database in the same Server
…All,
I am trying to create the Physical StandBy Database in the same server. Till last 2 Final steps, everything went on well. In the final steps, when I try to open the StandBy Database, it throws the following Error…
|
| 28 |
Forum: Weblogic & Application Server «»
Posted on: Thu, 28 January 2010 13:11 «»
By: her_fedo
OracleAS - Report Server
…Hi, I'm runnig Application Server on my computer, starting OC4J and namingservice, I could run my forms the issue is with the reports, show me: Unable to connect to report server: rep_2kgpkc1
I have rep_2kgpkc1.conf file and modified rwnetwork.conf. I …
|
| 29 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 13 February 2009 03:25 «»
By: deepbans
Re: Performance issue while runningthe query
…Dr.Raghunathan,
Here we are accessing each table remotely and each table contain huge number of records.
The original query is even too long.I have break the query and have created a temporary physical table(not global temp table) on my local …
|
| 30 |
Forum: Server Administration «»
Posted on: Fri, 29 August 2008 22:33 «»
By: suiren97
ORA-01652, ORA-02063
…error shows in alert log.
ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
ORA-02063: preceding line from ABC
Query select using dblink. The uable to extend temp segment is occur in local db (9i) or the remote db (10g)?
Kindly …
|
| 31 |
Forum: SQL & PL/SQL «»
Posted on: Wed, 28 May 2008 01:27 «»
By: sdhanuka
Re: Tablespace monitoring
…the spooling report code is
set arraysize 1
set heading on
set feedback off
set verify off
set linesize 150
set pages 9999
set echo off
set term off feed off trimspool on RECSEP off
set markup html on spool on entmap off preformat off
…
|
| 32 |
Forum: SQL & PL/SQL «»
Posted on: Fri, 23 March 2007 13:41 «»
By: Michel Cadot
Re: Script prob after changing from Oracle 9i to 10g R2 ORA-02021 ORA-30041
…
You cannot execute a DDL on a remote database, nobody can, this is a fact. However you can call a remote procedure that executes a DDL, for instance dbms_utility.exec_ddl_statement.
There is no quota on temp tablespace, they are useless, you don't …
|
| 33 |
Forum: Server Administration «»
Posted on: Wed, 13 December 2006 03:27 «»
By: gsgill76
ORA-04052: error occurred when looking up remote object REPADMIN.SYS@DB
…Hi, Basically I want to setup Replication between two servers, 'ZEN2K7' & 'DB' (Advanced master-to-master replication, Sync).
This is what i had done so far.
At Server 'ZEN2K7'
CONNECT system/manager@ZEN2K7
CREATE USER repadmin IDENTIFIED BY …
|
| 34 |
Forum: Networking and Gateways «»
Posted on: Mon, 15 May 2006 15:26 «»
By: nmacdannald
Re: Application Connection Error
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
2) …
|
| 35 |
Forum: Networking and Gateways «»
Posted on: Mon, 20 March 2006 17:42 «»
By: nmacdannald
Re: Connecting to Remote Server
…links.
Okay, here is the deal. I just spent two days reading about something that a person can explain in two minutes.
1) Make sure your tnsnames.ora have the same correct entries on both local and remote databases.
then lsnrctl reload
The …
|
| 36 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 March 2005 05:57 «»
By: Ken Jones
Re: Cursor Loop
…Todd, sorry for being a pain in the derriere but I have another question. I have created a directory on the filesystem and would like to write the above output into a file there. BUT I do not know how to reference what I need to write - see below:-
…
|
| 37 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 10 March 2005 05:42 «»
By: Ken Jones
Re: Cursor Loop
…
v_rc sys_refcursor;
v_user dba_users%rowtype;
v_node orcladmin.node_tns.node_tns%type;
begin
for rec_node in (select node_tns from orcladmin.node_tns where dbname like 'GM%' and dbname not in ('GMDU7','GMPA'))
loop
open v_rc for '…
|
| 38 |
Forum: SQL & PL/SQL «»
Posted on: Thu, 24 February 2005 13:49 «»
By: Todd Barry
Re: Cursor Loop
…is not tested, but it seems you would want something like (exception handling not shown):
declare
v_rc sys_refcursor;
v_user dba_users%rowtype;
begin
for rec_node in (select node_tns from orcladmin.node_tns) loop
open v_rc for '…
|
| 39 |
Forum: Networking and Gateways «»
Posted on: Mon, 09 February 2004 23:58 «»
By: Etienne LAUR
Intermittent 0313 error
…Have an VB6 application running with Oracle 8 Database.
This application works fine on the LAN, but there are intermittent 03113 errors when trying remote connexions.
Server : W2K;Oracle8
Client : W98,WXP
tnsnames.ora:
BACMRE01.CA12 =
(DESCRIPTION …
|
| 40 |
Forum: Windows «»
Posted on: Mon, 09 February 2004 23:55 «»
By: Etienne LAUR
Intermittent 0313 error
…Have an VB6 application running with Oracle 8 Database.
This application works fine on the LAN, but there are intermittent 03113 errors when trying remote connexions.
Server : W2K;Oracle8
Client : W98,WXP
tnsnames.ora:
BACMRE01.CA12 =
(DESCRIPTION …
|
Blog
Search
Help
Members
Register
Login
Home